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` = 334201 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334201 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90823,668844,611056,1028469,550615,463641,850298,216494,439369,89533,453095,812245,851197,405550,857555,909235,990633,422984,685813,143256,366052,1012442,735148,652958,188791,37372,246062,962424,621335,765081,374386,518794,999641,439245,118796,340289,343032,187886,994296,206471,826784,138629,777018,114439,151658,522343,376415,733376,891874,661607,507391,496610,273244,392059,763081,808756,958342,2363,435352,1013346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]