SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390411 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390411 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750882,904296,679171,716073,603019,304703,856705,890089,755446,462900,156475,43924,655718,776983,130244,551201,244003,879791,752081,505496,362714,904576,79985,534688,1000293,481190,916500,629667,404091,806290,786532,498275,294060,848960,502731,636152,257099,183293,526776,253414,853067,70227,185665,820010,606063,517195,580590,192324,343243,744291,357838,298804,816908,48346,203740,1047576,439988,818932,917903,501447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001883s ]