SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498220 LIMIT 1 [ RunTime:0.001936s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498220 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664954,1043574,988342,199703,435400,869138,415800,422702,449189,505659,655641,994347,379159,37458,446081,889909,583529,596605,65719,1025059,525542,732080,861370,710782,498625,113356,23081,245789,330788,635383,83629,689460,730998,78165,907741,29348,232858,181832,80441,920663,457288,679938,385087,727398,919748,185686,704250,776048,886429,453568,891436,738395,577291,788995,633261,847432,126396,232395,622286,952251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001088s ]