SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296920 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296920 [ RunTime:0.003010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541039,1012502,532787,1048131,1033225,903555,687819,8180,992872,807117,384434,620978,578760,608489,392951,959080,730155,308629,65490,806746,724756,264378,1034630,698614,881049,354205,463246,875196,651523,352777,336606,507167,764651,774829,722297,867479,564205,564565,486580,136747,200760,831444,31311,261927,690277,531651,67969,923229,669311,229671,27788,313875,321948,280032,737111,707399,502941,853951,1030087,198969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]