SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314983 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314983 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471717,961973,815788,77359,25823,182152,403508,698833,105947,961331,1025214,639110,749948,858693,155168,68463,877790,288614,497563,730100,1045957,498829,790678,466786,351450,219502,954837,773751,825775,401099,436520,995873,1000084,870640,468540,528529,360264,306209,61102,439780,760824,20704,218288,191433,1024258,833226,962525,577926,445940,702384,455848,57118,690452,312044,169964,96322,443644,220948,266818,1035103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]