SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102963 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102963 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542857,160113,517851,746118,10296,548421,544672,720767,881802,922636,935203,615767,909369,253586,325002,102739,1000049,1004534,87166,733975,774756,451249,570339,1016505,368613,15932,1042273,572448,363814,503760,8639,417621,91449,1006088,27565,644666,266514,70012,313342,393560,21641,751382,809181,474907,589196,494681,250435,948261,295144,801422,613925,802967,754577,522122,529428,409017,1006403,747264,932387,97332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]