SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304041 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304041 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334567,171617,558405,141951,512797,547656,374297,327793,871970,662344,277810,562385,535175,971282,962032,108320,84046,205114,279124,417655,767454,142225,379928,992363,931136,923917,365238,478588,862035,455832,458833,279720,310987,378392,356171,644230,835648,445879,524746,277252,360021,524809,434950,629070,574211,454582,550125,943878,152296,716902,909516,733575,467127,709631,50053,899054,65872,169491,662315,390389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]