SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143416 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143416 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132469,363187,733409,38388,599518,456396,76457,958984,39094,865729,832910,742167,171745,991306,682704,522452,770469,341832,145575,343354,955601,177319,53447,183846,788826,337103,478032,419143,524577,549391,241361,330430,62579,269615,353341,731888,68089,893098,283101,310885,866007,261122,240448,131220,792576,790853,857187,502723,314150,310304,618025,518238,601756,465277,76439,361836,485363,324923,437150,1037399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001108s ]