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` = 596578 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596578 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81132,481381,303138,287222,942548,282324,374214,327100,260137,953770,890034,645234,287244,278066,515526,197727,332070,732403,466247,109779,668511,748833,718827,101529,223910,366004,184777,457793,449488,1009444,304214,636178,656076,513668,992250,668883,971975,877717,1046638,674052,722448,845676,951008,197212,938851,219649,531388,49451,978302,890836,830530,498551,525538,893600,48519,808350,736556,472535,277648,627169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001141s ]