SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029678 LIMIT 1 [ RunTime:0.003858s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029678 [ RunTime:0.002627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344094,83457,435279,901137,278232,1008141,499710,184891,549709,1041951,569627,937662,636006,675984,13299,846753,336537,286766,4268,450495,741270,539468,896664,733109,555889,108206,988914,355384,61499,592578,245182,279876,8110,65637,32508,635541,883442,305654,355557,340093,274238,909673,27127,148519,198586,19913,998434,329361,459330,368266,638749,309134,753183,601369,881280,997940,905058,1023272,769728,954001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]