SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195073 LIMIT 1 [ RunTime:0.001950s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195073 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787677,207035,421302,1006126,512302,17587,782366,621605,575509,323985,160198,877901,527880,249199,772783,709312,306103,207109,584019,511595,200623,236233,952167,144529,629614,50753,223123,958048,762716,645334,187699,205319,589421,955655,404365,503574,323075,23754,294818,918543,373143,57969,733396,591931,210962,959411,426918,586080,88366,934039,292879,749232,25115,82248,762238,979307,487765,1035964,56646,240874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]