SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548585 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548585 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254594,981281,119217,695728,837807,864810,419619,154434,281035,43589,1006088,766098,865034,822918,94187,238970,886435,696130,179258,409822,534571,299963,4337,345508,42004,67107,352488,712869,707501,362959,663129,943876,82502,645935,740525,403323,292253,24258,702824,642169,539014,829870,49836,846625,63536,1014835,240911,1000600,564911,558777,709146,559496,156694,896325,270508,762157,939042,511903,865408,811149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]