SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287507 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287507 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008066,884288,360161,204116,742002,225845,990860,786800,796354,160620,1040984,292715,195601,315771,58525,351778,380870,651551,602515,170564,160089,162416,144040,489982,958568,737421,907967,162324,180112,776920,894938,992923,179530,958012,631797,553159,258871,472093,972957,1015631,1036996,284802,754078,364336,1039752,642249,220741,25747,274095,462553,121431,342482,694966,1023483,999920,248786,620777,261269,266425,1014148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003664s ]