SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001597s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025158 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025158 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12983,499222,618669,993414,1027589,243915,551626,158837,1048230,651375,34479,770251,918145,839675,806567,619946,196631,653737,765273,854198,114731,267192,132517,956903,906847,642453,940238,261340,900396,384180,126043,98126,110838,654740,493777,992811,41594,490336,642261,31504,809972,686465,232355,866225,871662,817560,444257,908570,881450,570971,683825,788051,855267,615267,117662,432663,402993,995937,321958,141777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]