SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401539 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401539 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464767,78706,622979,554303,130449,782877,353709,250700,461838,614149,642544,686062,305579,49158,945950,842957,915233,683553,605710,20791,1042637,629549,720852,1019131,50170,137572,364159,214494,854861,713100,600476,142776,1015185,171348,431450,914680,580054,738107,364569,963188,979509,20780,447430,84349,659831,1045172,117449,1042295,854230,410295,808152,634034,80526,91544,664880,803414,881102,259193,665417,768103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001160s ]