SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036469 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036469 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282207,845800,1010606,28922,1016386,89004,278493,361851,683547,793292,161884,923054,31101,948084,171059,368516,839144,577525,557982,273152,275601,707857,806369,533796,1029311,947730,607535,167897,947719,192489,684576,407632,226472,654090,777396,363873,429177,280639,170414,712013,54352,5352,798003,364027,368710,683274,380878,384448,183843,60278,536371,814128,262890,1045712,922651,802891,125640,10498,217063,771334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]