SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28018 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28018 [ RunTime:0.005300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964382,855221,457288,710035,505305,633161,559789,678262,450360,10796,203393,431244,715513,468486,539160,1000239,966733,956409,473070,165754,670230,217378,829517,113293,889013,385892,180437,653644,303153,743962,1036737,503540,1034167,992320,728523,549363,407953,305903,544621,940808,537183,133871,985506,538198,1011617,908315,591612,399283,378469,440544,946445,515873,239925,141674,238821,354058,62628,781825,527241,103230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]