SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260470 LIMIT 1 [ RunTime:0.000637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260470 [ RunTime:0.003451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518043,569387,179990,438929,585197,405079,643915,213523,204070,234497,573777,938359,991440,479162,61530,551498,429465,466738,1000765,214598,659567,347736,852003,519007,644078,884923,127778,545934,162512,917525,14863,73103,1009028,377706,143935,506405,264092,203943,353844,261697,899706,487700,934990,966198,131496,270773,870135,899014,443611,628414,790408,473516,1039533,138578,694681,527388,852226,453105,818198,361347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001933s ]