SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326081 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326081 [ RunTime:0.003623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046923,221872,557784,761662,380474,881741,588364,142252,305984,461443,341165,732376,427146,574012,491027,154692,902861,427245,310242,861773,598383,618002,479195,654719,240361,777339,200806,479924,65428,821655,748262,963348,193981,320536,913164,516822,941141,490087,437003,941388,199359,413859,145437,136978,674799,823078,711650,469209,182544,953756,696641,929088,708797,554362,803340,692348,967388,502519,257107,512694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]