SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475389 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475389 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425478,139438,814250,393550,440885,620345,119950,282338,722435,771990,1013838,167985,43825,562918,420055,357234,888376,71292,949524,348214,947940,351557,766701,39748,262497,578121,436410,129142,773259,558345,786285,588761,372738,660948,558409,81855,669063,703965,405890,1012488,803161,651301,276949,363007,856119,342432,1022473,475210,297276,35336,479375,479525,153394,1021669,624652,565361,693342,1009891,50545,767579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]