SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508127 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508127 [ RunTime:0.003626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841081,892072,1020504,951187,741978,75570,191438,507671,711532,774846,463965,882466,329529,766487,507459,972384,1016762,520229,701864,833611,1948,992491,700504,575662,246713,940585,724437,342246,872266,351741,582149,899453,638292,401003,201365,584045,37347,175876,811089,227066,445602,267991,362156,890160,814991,164006,446454,377567,606559,296371,249091,30209,599001,937285,102624,795590,784845,879166,170990,792633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508127 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508127 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]