SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517609 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517609 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526261,339505,1037137,249229,104925,290987,364293,749705,652221,429976,514080,610514,360710,848971,508274,88344,742935,767100,249199,1004583,725865,570277,739148,669922,314913,348658,512064,111795,441086,354021,448795,881589,567492,1024392,997890,532182,141078,321461,53881,68826,278930,665785,46993,486713,921345,564660,624471,982330,95021,1008145,678195,276937,747249,47258,787321,546115,961722,828347,512144,411470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]