SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402587 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402587 [ RunTime:0.003161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977202,740498,242814,542356,207170,1043311,508943,644657,506723,320086,398489,995693,275239,729735,237642,133968,735342,147758,737705,478334,1018309,112203,166635,339370,430786,859657,86025,397262,935208,964031,721072,990084,76779,713831,127801,486300,91152,444275,733221,582104,829648,30923,561694,1029400,673165,324040,771024,398748,773295,870102,952550,61787,570842,182667,1028991,679236,74622,574075,613909,326529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402587 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402587 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]