SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527014 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527014 [ RunTime:0.002263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74918,441788,596872,853649,954865,469516,700874,453436,302635,786268,985367,275340,973141,114481,217338,2190,748518,1007011,1017303,30473,461226,1023419,825222,592084,110945,907241,922633,922904,20131,747203,740017,515363,362257,459965,490364,75471,337416,163812,170268,635270,345197,883435,425457,720363,776238,217061,853036,718572,918270,543820,692142,113866,396214,440662,957424,531543,988246,867589,852712,877072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002809s ]