SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002962s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393576 LIMIT 1 [ RunTime:0.000809s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393576 [ RunTime:0.003019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382385,487572,413966,1038813,410683,316312,247445,488007,52115,966929,795472,806352,569230,817378,256966,662464,995849,630956,1022017,857293,273597,854561,778599,300459,41850,556673,322344,1047049,39467,226470,581125,997019,58265,65901,382778,616927,384713,234825,464735,778372,681420,685719,903591,358487,731417,738128,585371,818113,256680,751549,922164,851956,901890,979016,771240,865990,690029,483286,460590,931600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]