SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518393 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518393 [ RunTime:0.003591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769548,308144,545233,916181,257428,344381,339023,770443,902841,1047501,866077,439073,601641,403233,381782,228503,607414,1014611,34583,611073,163216,1047874,857502,112306,994291,545244,737430,798285,730147,457143,1045776,994632,371172,74434,912698,683398,737857,635190,419018,534728,744595,771949,56926,367509,311647,594441,826084,95087,217423,94551,532489,987943,21981,1007581,421373,124185,673866,411414,602146,823765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]