SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390716 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390716 [ RunTime:0.003027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560840,689606,967577,1034813,996854,770225,512950,796406,324959,904221,128668,370151,523037,195711,953335,119724,13757,723023,675526,18298,666140,1030038,111575,557588,303355,779124,702328,274461,539812,908310,642908,417048,412728,666030,994193,5929,717865,409533,174175,400921,74245,97148,672980,960237,971352,825431,664922,493360,849654,528760,839276,324863,799664,681645,330408,664800,845344,424393,90655,971095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]