SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683874 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683874 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562740,718994,798121,708167,388595,709898,619944,186337,57948,697733,264180,524801,1024712,547087,55423,87097,151158,598578,655931,248411,789987,257397,516853,285198,386404,61945,917525,1035984,502355,409497,215450,512928,632922,639134,597271,774259,278436,678540,1039414,1006973,560063,42915,60940,854979,112496,1039118,735674,192628,64373,240837,494218,63372,448318,868212,72475,650578,973157,719757,1016184,450182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]