SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548341 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548341 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118230,736314,486267,592797,22169,406224,359689,499012,433287,308396,660184,334300,755008,971574,972562,537352,894948,64831,916861,311389,381912,540194,949554,640970,203922,667686,584114,699126,273183,241753,830860,14553,1038428,718727,8414,613594,893222,804008,201270,937587,450965,513239,931950,927240,781274,690806,60236,302646,877709,977462,419896,675131,291078,327567,660956,525313,445670,520518,807438,642378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]