SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507323 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507323 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582366,879344,42556,939635,561433,402578,307604,1017540,1008087,867050,256791,606634,834544,818887,272137,312395,947042,516020,241783,773023,67788,14419,217738,1040428,832786,787677,168623,277418,633853,805737,325184,821997,495396,544652,757878,28193,821517,184765,890474,918562,916232,781992,337163,406479,531972,420282,520662,970300,676222,607483,641594,928701,975874,176219,899260,642620,473372,489395,1041863,35693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]