SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586404 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586404 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702325,196721,730025,710534,858451,153288,208619,451078,496607,915,251651,593370,440263,206970,648440,998026,136331,100689,861659,365318,434233,643080,25276,564633,614020,121486,504849,910966,446960,1042323,877384,944838,553665,547209,837897,257333,848879,590444,745295,334660,809501,728818,726872,669812,801580,448238,68285,358937,347948,383913,676107,664137,882830,655067,731005,164069,586634,560858,457998,483939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]