SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514146 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514146 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439008,195782,399994,84178,873434,101385,400564,220716,408842,709955,513842,866353,908987,377969,148594,424642,538378,182397,76034,907336,861780,1047310,348445,697187,309830,501992,1032857,521099,1006405,483307,644131,143678,18458,959477,517595,447149,727901,8790,450423,605207,108925,615103,750113,192494,284300,439968,71062,1016808,508098,798445,342809,811488,445882,282280,857399,542198,836860,869354,921463,296597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]