SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497564 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497564 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596487,1010443,212392,327847,591437,989616,553953,1011202,433546,794338,891149,1024572,706140,201999,497701,709722,949510,486386,437326,757868,204997,866526,425408,274557,53153,906476,759447,759768,223880,989300,576302,68886,10263,169190,606325,252844,78156,20045,332471,970185,208959,889080,548514,962870,217605,417228,915700,57798,1034778,537116,809322,618472,190583,169282,831911,315956,606907,496572,838007,509189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]