SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040104 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040104 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259483,326395,577299,361852,681419,110853,274473,481679,994869,738841,878247,696969,577740,776897,969498,603899,794401,438499,840379,465481,660009,467203,816621,585986,363477,1042749,92115,333646,785102,68872,600285,143562,418367,244083,102864,120692,449194,488591,1033715,788433,53491,382585,966606,173504,395935,728442,575858,922066,111370,365712,1034684,200703,686696,303165,992606,844920,322740,626965,675210,29795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]