SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468571 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468571 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60393,770564,215088,547636,571676,299423,570719,782940,82875,428055,517197,78282,708018,42009,653054,326600,160209,839786,380472,39867,532079,588381,696072,193097,866834,570508,336259,173919,18956,255572,803067,151532,689699,165693,6718,1019710,354513,566106,1020150,895714,923561,55253,1022146,187252,763303,505247,184369,9636,955885,205138,452679,936464,696670,388105,604380,1037954,730574,314627,74958,876249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000858s ]