SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511470 LIMIT 1 [ RunTime:0.001863s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511470 [ RunTime:0.005773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799796,969987,128346,620931,1035111,597089,431702,26075,167079,356708,235557,657694,1021776,606831,371167,273591,964612,595892,291707,427841,442310,404179,616042,970144,430972,15022,517692,120557,948173,921284,960246,403139,44972,648523,1018842,290744,802615,256599,569717,359600,14747,78651,320676,489271,404784,103025,1034036,664201,889891,5161,747247,564600,352359,478550,178756,440958,538065,702567,644917,1028488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001323s ]