SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319048 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319048 [ RunTime:0.004063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764167,464841,640367,1045251,708091,1042732,609760,835891,991651,1013006,118017,733495,496116,901714,109095,226250,150540,503216,412249,969540,43863,596228,164630,544288,691993,394149,676305,76037,500475,282150,548158,827670,946865,175365,40383,731192,562030,151379,963958,63162,283875,50659,980469,655688,320661,221887,639039,114856,211767,432644,998264,485053,549716,898281,833001,858244,864475,246697,57222,913997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]