SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293313 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293313 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184605,174078,690414,67090,543514,115429,865140,491383,949169,238327,335835,193263,400869,324900,968950,190478,683312,119394,757925,845078,838354,656960,688338,459501,1038757,964565,942542,184706,1006925,911659,612973,1025737,609961,925190,779860,558201,992105,586321,1025022,818548,290078,440207,423710,1012555,963717,915929,674261,597496,728722,309125,795758,298962,809400,648701,400080,176129,282075,488193,88227,332465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]