SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305034 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305034 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100018,730597,325275,186125,339191,1033389,254543,400272,171997,239246,467614,507263,887242,1016158,608648,1008894,504019,179309,733666,707795,510290,189387,1035278,507397,837273,58227,1028836,84684,217715,964976,718647,902174,352650,416387,358459,672577,20597,76104,394148,443104,135775,1018781,639657,955703,668588,835203,970315,814242,186333,195353,599402,434339,117942,765991,835527,657154,770847,114710,23098,74260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]