SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408249 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408249 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802876,341200,813442,211919,481723,280955,450796,119104,448495,638725,491493,150459,218311,642634,640995,367268,283734,194501,317662,165644,486843,55957,685827,379392,284723,983177,113729,890762,352117,390962,199185,282564,854531,367673,398189,400533,117028,395180,622799,22666,568957,886176,610621,880276,223923,531931,485452,491956,801596,872481,694690,414822,282612,835616,706648,789606,421325,925986,1839,365742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]