SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595320 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595320 [ RunTime:0.001038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252881,195248,840059,824828,175070,722048,265603,35642,611398,1041486,616575,114247,696287,540069,317609,550203,530467,303391,216902,398720,362582,609344,244632,1024078,404994,985386,28497,32650,901390,177992,772947,199063,265032,614537,901280,698078,955264,494142,580468,31950,168386,1047909,195756,538294,846213,670497,63655,315778,1046563,920516,770326,47251,106339,325224,215276,796284,1002280,918019,790983,451301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]