SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498315 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498315 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205517,333414,824903,675511,237902,943480,61212,128533,212097,226623,731080,525802,58997,477468,862372,626825,833122,997390,903543,416204,769306,718027,137097,840185,446033,146390,222522,247108,68911,147940,719129,872958,190957,990269,490198,929048,885325,913141,1002944,258304,979878,993944,392011,506385,718810,730334,364801,1006755,762184,1041669,1007682,273232,703880,548711,804393,172886,599749,206800,441482,188105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]