SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033572 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033572 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137336,83660,504149,22583,516558,561160,311096,187466,188968,87676,927456,21731,876835,46142,808354,250876,56659,854995,377132,606536,304623,120576,664631,311271,752129,935301,21487,852725,339286,87447,985277,441891,188434,911467,213334,159106,957781,563232,855726,171426,617701,570358,534596,194317,627534,340224,668801,809325,1036296,972499,70752,903512,265813,459024,124941,775680,246159,82373,590149,650603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]