SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105429 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105429 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140880,65028,404979,871665,1044825,925094,859796,903214,65802,566132,72834,1004817,489344,748395,575066,304325,197625,155037,140649,33837,462813,949121,716145,537943,52434,366367,716866,566524,370528,109431,679830,587850,267165,565484,940639,6370,999283,210234,940443,541852,59045,898358,729605,537685,649549,240547,257964,842804,337464,799904,1047342,28559,53362,596457,645763,1039149,735516,58510,255744,142659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]