SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497591 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497591 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502378,398166,908812,626003,816018,630804,782259,759701,493162,216093,777823,88425,889026,534264,958989,433568,803149,398279,798643,1018172,28131,825190,417679,289006,443879,153531,78380,792867,575477,1015757,617088,526368,1004988,64740,45911,351475,736480,191961,944841,473909,866010,590597,258370,777642,819050,961655,430727,1012000,305470,422076,793269,13590,130565,939282,497133,576283,66563,165090,11114,443405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001580s ]