SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423610 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423610 [ RunTime:0.002612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58092,630645,366519,450510,97792,407150,997503,647463,709223,633036,106333,806162,197178,754440,767047,466538,674839,179986,902777,595983,793705,1025593,290422,5076,260701,185431,714089,782188,575455,211847,927802,1032158,872518,635452,412851,820079,241527,494550,290504,439149,205774,250582,62671,547415,844678,834292,922422,157174,335819,718509,470067,250030,87588,788601,817921,603200,854820,921329,154696,936858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]