SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420083 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420083 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296186,600108,240911,1023260,80929,640510,170131,144041,183546,919011,432010,651654,880470,206276,673638,150289,285778,1044340,404433,499021,903911,405307,699714,702095,272331,455538,231356,482122,155790,254639,69431,850470,716728,643808,261925,225015,558496,436725,178938,809224,597357,862083,263113,60655,820255,735736,969214,741167,1042460,89701,376470,611318,1031548,487030,1023284,743238,413523,578317,700275,1011043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]