SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901043 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901043 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646923,55612,931067,527161,584622,759586,265148,400195,651030,292031,896630,956689,33320,719810,180286,659345,929620,712827,733562,502991,674903,521450,598624,606757,326313,72831,760475,962778,181235,210382,122417,427637,741062,975436,200986,1039962,235305,671404,173028,215052,725756,896685,571182,550739,161261,461119,5937,663718,169957,594810,965397,132840,88561,581316,338547,505502,409504,232167,502590,285767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001015s ]