SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567726 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567726 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421702,839206,139010,423244,356822,30775,101870,101388,255126,780481,861208,1038481,461338,921514,1013045,664286,1047476,402733,708054,245616,555539,500539,366893,1004551,473619,312424,1028664,678741,565665,819694,321808,874441,23435,272888,841736,173031,387113,566564,617955,625734,109266,72325,652393,745137,123910,118837,604119,225277,340367,51715,496421,119010,342870,245075,120181,835356,179168,764194,432370,226606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]