SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552393 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552393 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14008,320187,954198,689298,1023181,955292,50458,971976,729760,378692,656495,325112,1038864,681286,33148,985180,84117,162140,200728,508842,288397,94271,518311,254530,793414,871222,922763,44159,843757,175598,431860,645670,171126,700260,840747,463099,423141,638095,760313,731455,473893,1025687,523152,1021873,962429,23406,9503,520195,133384,359978,665286,365049,109458,169263,725001,817827,752965,269134,1043783,437339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]