SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020573 LIMIT 1 [ RunTime:0.002845s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020573 [ RunTime:0.006528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931096,317204,952095,782368,140845,51872,510781,319782,346507,302187,474996,214487,225901,572341,1039551,164490,1034827,307725,82410,29057,790136,256371,698041,117600,894191,924079,873303,669717,118322,1031443,140062,58413,504005,866828,516105,689260,180025,518348,821206,894287,540964,899926,148126,543312,37857,819844,239319,642102,191865,577157,663405,915026,928521,390313,117019,517966,481161,617147,89266,357531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]