SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41810 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41810 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745534,535116,247236,589910,996489,883617,1018458,768848,63778,17626,485279,580607,618478,809538,693836,713789,245438,767676,856991,595250,255010,1011418,173367,916836,109228,1020473,561913,641977,902110,911958,537191,325675,563376,541770,779300,434732,1001577,459757,751900,590711,308343,194673,469343,485756,395437,667836,529925,595217,676250,674861,796287,918035,682026,222597,267102,619220,315421,1014422,17423,845612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]