SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50268 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50268 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196698,384570,410362,189022,552638,787668,169435,555438,650255,565321,335823,835199,704813,432687,216675,704860,698929,997095,131178,419431,348747,619170,900727,730555,607090,396355,69493,1040916,161962,161876,774052,413514,431227,628590,433983,978943,768860,983066,1010610,61462,858716,951502,817765,152388,325435,406152,238948,991544,139875,456714,644590,1027410,404056,120424,532700,790163,131909,864991,851790,250804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001882s ]