SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265733 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265733 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283055,226400,500343,1022808,967639,890460,673669,233970,44228,692117,39291,1039036,960914,331304,890048,786295,10419,126369,507230,376660,151680,339199,583988,575459,253446,296896,728519,213086,168242,330024,116484,540130,215447,884910,350242,768884,251832,111455,689871,147708,350291,352434,299921,128997,575727,645115,430811,202840,80402,746268,360918,871278,349780,86011,313172,365676,181633,53412,216821,575921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]