SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101920 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101920 [ RunTime:0.008751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650231,605027,783898,1004136,375397,1014209,813861,846942,655484,1041018,318395,605250,317392,628231,938280,221589,88312,411926,1021837,810151,793132,142693,752440,813474,628486,69263,696001,229919,22063,281283,265729,369298,27763,890926,3803,816328,41581,47585,231991,310859,987857,180370,227214,140642,1012895,84951,73477,895836,897109,604840,664312,315659,1028335,828171,82495,398520,996821,167637,961842,44556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]