SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557322 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557322 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662446,179886,214685,978207,846480,503201,655284,852738,342621,171383,421235,348869,742824,77506,365658,369568,161322,693715,585911,766419,608383,277225,835145,249123,149113,913997,923070,705476,184938,411799,170359,616656,705061,290081,182800,517350,443263,292760,15216,78370,144848,894483,721727,64362,589057,677072,167832,978353,206183,733351,570863,6345,193669,764161,210153,701603,175100,914696,545688,1038675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]