SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517810 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517810 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948506,234337,840443,645083,794372,860247,1024785,659568,571583,276125,205882,579709,821850,98551,982860,39700,835393,822549,932539,981761,658409,282217,776642,939412,539609,507759,761527,998593,246797,854685,164086,192475,400867,562054,193875,126099,26185,727009,914608,504624,366414,429336,777476,958570,777924,686188,821426,750731,294473,855834,305024,338779,29882,880379,513158,380081,586777,722578,518207,294590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]