SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296713 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296713 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284156,888671,155896,547883,723272,25548,925621,440218,271668,650673,576579,78251,323795,928407,901673,265689,695105,908455,127249,26588,70921,956987,795165,460050,456969,889042,418799,233315,858011,445364,899395,392601,144624,916858,661556,95704,262068,185878,322592,458318,563225,983211,356108,73119,884819,905298,687094,846706,841699,598663,193426,442262,243130,167925,896884,822185,269521,233273,193104,736757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]