SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043500 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043500 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142884,991612,91241,1025865,452923,443481,449961,203765,686911,952631,894016,902071,987944,514539,184117,673642,615532,826527,886082,116824,5252,53108,573005,663452,310497,185723,193180,266986,1724,536831,884018,653014,134297,983302,1022279,804545,211794,386235,964230,439993,951979,902752,937586,492054,702677,996109,458682,447129,361159,996897,42237,457166,1042136,462307,540426,96450,979794,819468,700574,78873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]