SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181041 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181041 [ RunTime:0.002360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427210,1018390,145202,944006,801166,742715,787761,781391,367598,505981,805527,699795,979374,741355,577372,609211,370881,920950,516202,864163,142895,106130,179598,611533,527364,336543,886334,138532,279768,129829,732907,770068,425994,82476,66757,496845,103555,911465,910977,463036,825666,847022,812405,594755,384064,775625,374316,422301,913881,365898,698040,240299,166601,881809,547498,69388,647476,735254,826631,619894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]