SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310139 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310139 [ RunTime:0.002390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362303,1010788,314612,441360,203649,238873,696287,979927,575031,17403,524878,927344,183415,531391,415485,337309,57942,824583,260881,710780,628561,261515,530264,78023,17576,631361,797179,733972,475161,82162,952086,139612,929510,1007741,672833,798297,522246,380803,439271,299468,344558,878192,142710,768590,879796,584755,625414,429359,834662,779476,456605,400148,579166,547918,977281,706739,777439,181043,144721,1039082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]