SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501114 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501114 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696487,249108,696888,411660,518632,622914,199351,302721,956257,725040,731325,357284,157305,157402,925494,792571,144743,848182,182010,591441,305079,524612,975540,311048,415436,25882,603561,147065,369951,216072,284292,252171,725850,211666,795521,11877,103209,573567,519376,224371,445591,484012,217175,915732,722216,503303,114599,829125,918494,252301,434631,792982,686278,115095,927678,390302,530357,488295,248970,23867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]