SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30304 LIMIT 1 [ RunTime:0.002641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30304 [ RunTime:0.006287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40178,1044128,1038525,94449,961741,733964,643031,901391,692789,182951,792185,900299,298678,520891,615815,435465,349292,622212,1024547,226688,221108,806110,765333,848005,644494,216980,1021878,833639,267504,1022398,120940,101081,298257,191927,321619,978966,970545,498798,140451,327925,265654,380092,167304,659337,245022,797285,865535,671322,774787,554144,109633,622509,869392,567656,591893,394384,917950,438158,782031,218084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003668s ]