SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518102 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518102 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811133,1037123,832638,934054,995299,46432,577180,111256,911,654952,453837,711739,284860,839554,358941,423772,962050,145761,150036,591760,1047863,51327,495559,579202,528094,424226,809728,402085,291178,484863,146269,951716,702897,781374,611986,791864,976282,321735,723984,838610,160302,449894,746615,988636,1003297,290106,240567,151595,172250,568941,618544,301291,904439,292182,329560,977396,1042851,55930,845305,884916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]