SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589920 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589920 [ RunTime:0.004197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445673,916915,383150,496327,376667,701519,650902,779469,23801,684987,603308,449581,227898,15717,455932,240423,367328,249319,263949,794132,1021484,392139,1043815,1037765,936025,457623,700891,538261,136580,773938,557124,26640,301728,300493,1002014,48633,909900,288074,195280,496738,935048,346950,759454,299047,9877,211631,189459,292169,965635,28427,160012,227754,974760,568901,531137,694372,934091,167783,313075,189656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]