SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455431 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455431 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945020,590733,245340,170054,667846,337225,334748,134518,676600,627351,952726,82018,618793,551821,52503,72415,538482,194984,608077,150717,281,412027,866819,792454,234808,31595,530197,165287,232476,353120,918089,218184,371044,280650,771812,787416,120307,964750,71170,996138,432675,354965,303521,15479,101613,572704,447840,856247,331021,530785,494493,490712,370484,910700,615129,765417,550004,243289,22968,514725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]