SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543748 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543748 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110407,611668,576597,913281,76036,602365,382039,839576,855489,1003812,559001,746147,995999,712351,642031,113785,501557,506175,131413,423557,532655,202580,393248,661025,763314,513063,159565,227898,685898,525114,343215,264397,957902,466911,5172,56116,987201,840414,471405,449350,305377,46917,237754,840938,73350,290121,703144,677116,82024,23545,764008,685071,742370,379783,683037,260308,713799,679839,431996,731030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]