SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418019 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418019 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589423,813621,346099,717578,197706,334667,491389,297543,402051,544036,406134,423354,404423,813060,836175,335774,254895,82847,135063,246190,172084,820289,913959,620057,784560,153451,762418,965102,541239,295295,754695,5553,481213,386311,164019,154480,628288,452223,950647,236927,654209,484429,357865,726727,105997,263549,815598,549570,84300,631133,251478,428337,195841,927873,166574,33038,630491,206868,425016,362534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]